package com.mhc.suzuki.dal.query;


import com.subaru.common.query.BaseCriteria;
import com.subaru.common.query.BaseQuery;
import org.apache.commons.lang.builder.ReflectionToStringBuilder;
import org.apache.commons.lang.builder.ToStringStyle;

import java.io.Serializable;

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.List;

public class NotaryMortgageQuery extends BaseQuery implements Serializable {
    private static final long serialVersionUID = 1L;

    public NotaryMortgageQuery() {
        super();
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        super.oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This class corresponds to the database table pcl_notary_mortgage
     */
         protected abstract static class GeneratedCriteria extends BaseCriteria {

        protected GeneratedCriteria() {
            super();
        }

        public Criteria andMortgageIdIsNull() {
            addCriterion("mortgage_id is null");
            return (Criteria) this;
        }

        public Criteria andMortgageIdIsNotNull() {
            addCriterion("mortgage_id is not null");
            return (Criteria) this;
        }

        public Criteria andMortgageIdEqualTo(Long value) {
            addCriterion("mortgage_id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andMortgageIdNotEqualTo(Long value) {
            addCriterion("mortgage_id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria anMortgageIdGreaterThan(Long value) {
            addCriterion("mortgage_id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andMortgageIdGreaterThanOrEqualTo(Long value) {
            addCriterion("mortgage_id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andMortgageIdLessThan(Long value) {
            addCriterion("mortgage_id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andMortgageIdLessThanOrEqualTo(Long value) {
            addCriterion("mortgage_id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andMortgageIdIn(List<Long> values) {
            addCriterion("mortgage_id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andMortgageIdNotIn(List<Long> values) {
            addCriterion("mortgage_id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andMortgageIdBetween(Long value1, Long value2) {
            addCriterion("mortgage_id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andMortgageIdNotBetween(Long value1, Long value2) {
            addCriterion("mortgage_id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNull() {
            addCriterion("gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNotNull() {
            addCriterion("gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateEqualTo(LocalDate value) {
            addCriterion("gmt_create =", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotEqualTo(LocalDate value) {
            addCriterion("gmt_create <>", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThan(LocalDate value) {
            addCriterion("gmt_create >", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_create >=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThan(LocalDate value) {
            addCriterion("gmt_create <", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_create <=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIn(List<LocalDate> values) {
            addCriterion("gmt_create in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotIn(List<LocalDate> values) {
            addCriterion("gmt_create not in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_create between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_create not between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNull() {
            addCriterion("gmt_modified is null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNotNull() {
            addCriterion("gmt_modified is not null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedEqualTo(LocalDate value) {
            addCriterion("gmt_modified =", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotEqualTo(LocalDate value) {
            addCriterion("gmt_modified <>", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThan(LocalDate value) {
            addCriterion("gmt_modified >", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_modified >=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThan(LocalDate value) {
            addCriterion("gmt_modified <", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_modified <=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIn(List<LocalDate> values) {
            addCriterion("gmt_modified in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotIn(List<LocalDate> values) {
            addCriterion("gmt_modified not in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_modified between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_modified not between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("order_no is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("order_no is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("order_no =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("order_no <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("order_no >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("order_no >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("order_no <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("order_no <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("order_no like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("order_no not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("order_no in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("order_no not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("order_no between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("order_no not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andRegistryDateIsNull() {
            addCriterion("registry_date is null");
            return (Criteria) this;
        }

        public Criteria andRegistryDateIsNotNull() {
            addCriterion("registry_date is not null");
            return (Criteria) this;
        }

        public Criteria andRegistryDateEqualTo(LocalDateTime value) {
            addCriterion("registry_date =", value, "registryDate");
            return (Criteria) this;
        }

        public Criteria andRegistryDateNotEqualTo(LocalDateTime value) {
            addCriterion("registry_date <>", value, "registryDate");
            return (Criteria) this;
        }

        public Criteria andRegistryDateGreaterThan(LocalDateTime value) {
            addCriterion("registry_date >", value, "registryDate");
            return (Criteria) this;
        }

        public Criteria andRegistryDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("registry_date >=", value, "registryDate");
            return (Criteria) this;
        }

        public Criteria andRegistryDateLessThan(LocalDateTime value) {
            addCriterion("registry_date <", value, "registryDate");
            return (Criteria) this;
        }

        public Criteria andRegistryDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("registry_date <=", value, "registryDate");
            return (Criteria) this;
        }

        public Criteria andRegistryDateLike(LocalDateTime value) {
            addCriterion("registry_date like", value, "registryDate");
            return (Criteria) this;
        }

        public Criteria andRegistryDateNotLike(LocalDateTime value) {
            addCriterion("registry_date not like", value, "registryDate");
            return (Criteria) this;
        }

        public Criteria andRegistryDateIn(List<LocalDateTime> values) {
            addCriterion("registry_date in", values, "registryDate");
            return (Criteria) this;
        }

        public Criteria andRegistryDateNotIn(List<LocalDateTime> values) {
            addCriterion("registry_date not in", values, "registryDate");
            return (Criteria) this;
        }

        public Criteria andRegistryDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("registry_date between", value1, value2, "registryDate");
            return (Criteria) this;
        }

        public Criteria andRegistryDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("registry_date not between", value1, value2, "registryDate");
            return (Criteria) this;
        }

        public Criteria andRegistryAddrIsNull() {
            addCriterion("registry_addr is null");
            return (Criteria) this;
        }

        public Criteria andRegistryAddrIsNotNull() {
            addCriterion("registry_addr is not null");
            return (Criteria) this;
        }

        public Criteria andRegistryAddrEqualTo(String value) {
            addCriterion("registry_addr =", value, "registryAddr");
            return (Criteria) this;
        }

        public Criteria andRegistryAddrNotEqualTo(String value) {
            addCriterion("registry_addr <>", value, "registryAddr");
            return (Criteria) this;
        }

        public Criteria andRegistryAddrGreaterThan(String value) {
            addCriterion("registry_addr >", value, "registryAddr");
            return (Criteria) this;
        }

        public Criteria andRegistryAddrGreaterThanOrEqualTo(String value) {
            addCriterion("registry_addr >=", value, "registryAddr");
            return (Criteria) this;
        }

        public Criteria andRegistryAddrLessThan(String value) {
            addCriterion("registry_addr <", value, "registryAddr");
            return (Criteria) this;
        }

        public Criteria andRegistryAddrLessThanOrEqualTo(String value) {
            addCriterion("registry_addr <=", value, "registryAddr");
            return (Criteria) this;
        }

        public Criteria andRegistryAddrLike(String value) {
            addCriterion("registry_addr like", value, "registryAddr");
            return (Criteria) this;
        }

        public Criteria andRegistryAddrNotLike(String value) {
            addCriterion("registry_addr not like", value, "registryAddr");
            return (Criteria) this;
        }

        public Criteria andRegistryAddrIn(List<String> values) {
            addCriterion("registry_addr in", values, "registryAddr");
            return (Criteria) this;
        }

        public Criteria andRegistryAddrNotIn(List<String> values) {
            addCriterion("registry_addr not in", values, "registryAddr");
            return (Criteria) this;
        }

        public Criteria andRegistryAddrBetween(String value1, String value2) {
            addCriterion("registry_addr between", value1, value2, "registryAddr");
            return (Criteria) this;
        }

        public Criteria andRegistryAddrNotBetween(String value1, String value2) {
            addCriterion("registry_addr not between", value1, value2, "registryAddr");
            return (Criteria) this;
        }

        public Criteria andLicensePlateNoIsNull() {
            addCriterion("license_plate_no is null");
            return (Criteria) this;
        }

        public Criteria andLicensePlateNoIsNotNull() {
            addCriterion("license_plate_no is not null");
            return (Criteria) this;
        }

        public Criteria andLicensePlateNoEqualTo(String value) {
            addCriterion("license_plate_no =", value, "licensePlateNo");
            return (Criteria) this;
        }

        public Criteria andLicensePlateNoNotEqualTo(String value) {
            addCriterion("license_plate_no <>", value, "licensePlateNo");
            return (Criteria) this;
        }

        public Criteria andLicensePlateNoGreaterThan(String value) {
            addCriterion("license_plate_no >", value, "licensePlateNo");
            return (Criteria) this;
        }

        public Criteria andLicensePlateNoGreaterThanOrEqualTo(String value) {
            addCriterion("license_plate_no >=", value, "licensePlateNo");
            return (Criteria) this;
        }

        public Criteria andLicensePlateNoLessThan(String value) {
            addCriterion("license_plate_no <", value, "licensePlateNo");
            return (Criteria) this;
        }

        public Criteria andLicensePlateNoLessThanOrEqualTo(String value) {
            addCriterion("license_plate_no <=", value, "licensePlateNo");
            return (Criteria) this;
        }

        public Criteria andLicensePlateNoLike(String value) {
            addCriterion("license_plate_no like", value, "licensePlateNo");
            return (Criteria) this;
        }

        public Criteria andLicensePlateNoNotLike(String value) {
            addCriterion("license_plate_no not like", value, "licensePlateNo");
            return (Criteria) this;
        }

        public Criteria andLicensePlateNoIn(List<String> values) {
            addCriterion("license_plate_no in", values, "licensePlateNo");
            return (Criteria) this;
        }

        public Criteria andLicensePlateNoNotIn(List<String> values) {
            addCriterion("license_plate_no not in", values, "licensePlateNo");
            return (Criteria) this;
        }

        public Criteria andLicensePlateNoBetween(String value1, String value2) {
            addCriterion("license_plate_no between", value1, value2, "licensePlateNo");
            return (Criteria) this;
        }

        public Criteria andLicensePlateNoNotBetween(String value1, String value2) {
            addCriterion("license_plate_no not between", value1, value2, "licensePlateNo");
            return (Criteria) this;
        }

        public Criteria andNotarSubmitDateIsNull() {
            addCriterion("notar_submit_date is null");
            return (Criteria) this;
        }

        public Criteria andNotarSubmitDateIsNotNull() {
            addCriterion("notar_submit_date is not null");
            return (Criteria) this;
        }

        public Criteria andNotarSubmitDateEqualTo(LocalDateTime value) {
            addCriterion("notar_submit_date =", value, "notarSubmitDate");
            return (Criteria) this;
        }

        public Criteria andNotarSubmitDateNotEqualTo(LocalDateTime value) {
            addCriterion("notar_submit_date <>", value, "notarSubmitDate");
            return (Criteria) this;
        }

        public Criteria andNotarSubmitDateGreaterThan(LocalDateTime value) {
            addCriterion("notar_submit_date >", value, "notarSubmitDate");
            return (Criteria) this;
        }

        public Criteria andNotarSubmitDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("notar_submit_date >=", value, "notarSubmitDate");
            return (Criteria) this;
        }

        public Criteria andNotarSubmitDateLessThan(LocalDateTime value) {
            addCriterion("notar_submit_date <", value, "notarSubmitDate");
            return (Criteria) this;
        }

        public Criteria andNotarSubmitDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("notar_submit_date <=", value, "notarSubmitDate");
            return (Criteria) this;
        }

        public Criteria andNotarSubmitDateLike(LocalDateTime value) {
            addCriterion("notar_submit_date like", value, "notarSubmitDate");
            return (Criteria) this;
        }

        public Criteria andNotarSubmitDateNotLike(LocalDateTime value) {
            addCriterion("notar_submit_date not like", value, "notarSubmitDate");
            return (Criteria) this;
        }

        public Criteria andNotarSubmitDateIn(List<LocalDateTime> values) {
            addCriterion("notar_submit_date in", values, "notarSubmitDate");
            return (Criteria) this;
        }

        public Criteria andNotarSubmitDateNotIn(List<LocalDateTime> values) {
            addCriterion("notar_submit_date not in", values, "notarSubmitDate");
            return (Criteria) this;
        }

        public Criteria andNotarSubmitDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("notar_submit_date between", value1, value2, "notarSubmitDate");
            return (Criteria) this;
        }

        public Criteria andNotarSubmitDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("notar_submit_date not between", value1, value2, "notarSubmitDate");
            return (Criteria) this;
        }

        public Criteria andNotarReceiptDateIsNull() {
            addCriterion("notar_receipt_date is null");
            return (Criteria) this;
        }

        public Criteria andNotarReceiptDateIsNotNull() {
            addCriterion("notar_receipt_date is not null");
            return (Criteria) this;
        }

        public Criteria andNotarReceiptDateEqualTo(LocalDateTime value) {
            addCriterion("notar_receipt_date =", value, "notarReceiptDate");
            return (Criteria) this;
        }

        public Criteria andNotarReceiptDateNotEqualTo(LocalDateTime value) {
            addCriterion("notar_receipt_date <>", value, "notarReceiptDate");
            return (Criteria) this;
        }

        public Criteria andNotarReceiptDateGreaterThan(LocalDateTime value) {
            addCriterion("notar_receipt_date >", value, "notarReceiptDate");
            return (Criteria) this;
        }

        public Criteria andNotarReceiptDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("notar_receipt_date >=", value, "notarReceiptDate");
            return (Criteria) this;
        }

        public Criteria andNotarReceiptDateLessThan(LocalDateTime value) {
            addCriterion("notar_receipt_date <", value, "notarReceiptDate");
            return (Criteria) this;
        }

        public Criteria andNotarReceiptDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("notar_receipt_date <=", value, "notarReceiptDate");
            return (Criteria) this;
        }

        public Criteria andNotarReceiptDateLike(LocalDateTime value) {
            addCriterion("notar_receipt_date like", value, "notarReceiptDate");
            return (Criteria) this;
        }

        public Criteria andNotarReceiptDateNotLike(LocalDateTime value) {
            addCriterion("notar_receipt_date not like", value, "notarReceiptDate");
            return (Criteria) this;
        }

        public Criteria andNotarReceiptDateIn(List<LocalDateTime> values) {
            addCriterion("notar_receipt_date in", values, "notarReceiptDate");
            return (Criteria) this;
        }

        public Criteria andNotarReceiptDateNotIn(List<LocalDateTime> values) {
            addCriterion("notar_receipt_date not in", values, "notarReceiptDate");
            return (Criteria) this;
        }

        public Criteria andNotarReceiptDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("notar_receipt_date between", value1, value2, "notarReceiptDate");
            return (Criteria) this;
        }

        public Criteria andNotarReceiptDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("notar_receipt_date not between", value1, value2, "notarReceiptDate");
            return (Criteria) this;
        }

        public Criteria andNotarPostDateIsNull() {
            addCriterion("notar_post_date is null");
            return (Criteria) this;
        }

        public Criteria andNotarPostDateIsNotNull() {
            addCriterion("notar_post_date is not null");
            return (Criteria) this;
        }

        public Criteria andNotarPostDateEqualTo(LocalDateTime value) {
            addCriterion("notar_post_date =", value, "notarPostDate");
            return (Criteria) this;
        }

        public Criteria andNotarPostDateNotEqualTo(LocalDateTime value) {
            addCriterion("notar_post_date <>", value, "notarPostDate");
            return (Criteria) this;
        }

        public Criteria andNotarPostDateGreaterThan(LocalDateTime value) {
            addCriterion("notar_post_date >", value, "notarPostDate");
            return (Criteria) this;
        }

        public Criteria andNotarPostDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("notar_post_date >=", value, "notarPostDate");
            return (Criteria) this;
        }

        public Criteria andNotarPostDateLessThan(LocalDateTime value) {
            addCriterion("notar_post_date <", value, "notarPostDate");
            return (Criteria) this;
        }

        public Criteria andNotarPostDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("notar_post_date <=", value, "notarPostDate");
            return (Criteria) this;
        }

        public Criteria andNotarPostDateLike(LocalDateTime value) {
            addCriterion("notar_post_date like", value, "notarPostDate");
            return (Criteria) this;
        }

        public Criteria andNotarPostDateNotLike(LocalDateTime value) {
            addCriterion("notar_post_date not like", value, "notarPostDate");
            return (Criteria) this;
        }

        public Criteria andNotarPostDateIn(List<LocalDateTime> values) {
            addCriterion("notar_post_date in", values, "notarPostDate");
            return (Criteria) this;
        }

        public Criteria andNotarPostDateNotIn(List<LocalDateTime> values) {
            addCriterion("notar_post_date not in", values, "notarPostDate");
            return (Criteria) this;
        }

        public Criteria andNotarPostDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("notar_post_date between", value1, value2, "notarPostDate");
            return (Criteria) this;
        }

        public Criteria andNotarPostDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("notar_post_date not between", value1, value2, "notarPostDate");
            return (Criteria) this;
        }

        public Criteria andRegCertNoIsNull() {
            addCriterion("reg_cert_no is null");
            return (Criteria) this;
        }

        public Criteria andRegCertNoIsNotNull() {
            addCriterion("reg_cert_no is not null");
            return (Criteria) this;
        }

        public Criteria andRegCertNoEqualTo(String value) {
            addCriterion("reg_cert_no =", value, "regCertNo");
            return (Criteria) this;
        }

        public Criteria andRegCertNoNotEqualTo(String value) {
            addCriterion("reg_cert_no <>", value, "regCertNo");
            return (Criteria) this;
        }

        public Criteria andRegCertNoGreaterThan(String value) {
            addCriterion("reg_cert_no >", value, "regCertNo");
            return (Criteria) this;
        }

        public Criteria andRegCertNoGreaterThanOrEqualTo(String value) {
            addCriterion("reg_cert_no >=", value, "regCertNo");
            return (Criteria) this;
        }

        public Criteria andRegCertNoLessThan(String value) {
            addCriterion("reg_cert_no <", value, "regCertNo");
            return (Criteria) this;
        }

        public Criteria andRegCertNoLessThanOrEqualTo(String value) {
            addCriterion("reg_cert_no <=", value, "regCertNo");
            return (Criteria) this;
        }

        public Criteria andRegCertNoLike(String value) {
            addCriterion("reg_cert_no like", value, "regCertNo");
            return (Criteria) this;
        }

        public Criteria andRegCertNoNotLike(String value) {
            addCriterion("reg_cert_no not like", value, "regCertNo");
            return (Criteria) this;
        }

        public Criteria andRegCertNoIn(List<String> values) {
            addCriterion("reg_cert_no in", values, "regCertNo");
            return (Criteria) this;
        }

        public Criteria andRegCertNoNotIn(List<String> values) {
            addCriterion("reg_cert_no not in", values, "regCertNo");
            return (Criteria) this;
        }

        public Criteria andRegCertNoBetween(String value1, String value2) {
            addCriterion("reg_cert_no between", value1, value2, "regCertNo");
            return (Criteria) this;
        }

        public Criteria andRegCertNoNotBetween(String value1, String value2) {
            addCriterion("reg_cert_no not between", value1, value2, "regCertNo");
            return (Criteria) this;
        }

        public Criteria andRegCertReceiptDateIsNull() {
            addCriterion("reg_cert_receipt_date is null");
            return (Criteria) this;
        }

        public Criteria andRegCertReceiptDateIsNotNull() {
            addCriterion("reg_cert_receipt_date is not null");
            return (Criteria) this;
        }

        public Criteria andRegCertReceiptDateEqualTo(LocalDateTime value) {
            addCriterion("reg_cert_receipt_date =", value, "regCertReceiptDate");
            return (Criteria) this;
        }

        public Criteria andRegCertReceiptDateNotEqualTo(LocalDateTime value) {
            addCriterion("reg_cert_receipt_date <>", value, "regCertReceiptDate");
            return (Criteria) this;
        }

        public Criteria andRegCertReceiptDateGreaterThan(LocalDateTime value) {
            addCriterion("reg_cert_receipt_date >", value, "regCertReceiptDate");
            return (Criteria) this;
        }

        public Criteria andRegCertReceiptDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("reg_cert_receipt_date >=", value, "regCertReceiptDate");
            return (Criteria) this;
        }

        public Criteria andRegCertReceiptDateLessThan(LocalDateTime value) {
            addCriterion("reg_cert_receipt_date <", value, "regCertReceiptDate");
            return (Criteria) this;
        }

        public Criteria andRegCertReceiptDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("reg_cert_receipt_date <=", value, "regCertReceiptDate");
            return (Criteria) this;
        }

        public Criteria andRegCertReceiptDateLike(LocalDateTime value) {
            addCriterion("reg_cert_receipt_date like", value, "regCertReceiptDate");
            return (Criteria) this;
        }

        public Criteria andRegCertReceiptDateNotLike(LocalDateTime value) {
            addCriterion("reg_cert_receipt_date not like", value, "regCertReceiptDate");
            return (Criteria) this;
        }

        public Criteria andRegCertReceiptDateIn(List<LocalDateTime> values) {
            addCriterion("reg_cert_receipt_date in", values, "regCertReceiptDate");
            return (Criteria) this;
        }

        public Criteria andRegCertReceiptDateNotIn(List<LocalDateTime> values) {
            addCriterion("reg_cert_receipt_date not in", values, "regCertReceiptDate");
            return (Criteria) this;
        }

        public Criteria andRegCertReceiptDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("reg_cert_receipt_date between", value1, value2, "regCertReceiptDate");
            return (Criteria) this;
        }

        public Criteria andRegCertReceiptDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("reg_cert_receipt_date not between", value1, value2, "regCertReceiptDate");
            return (Criteria) this;
        }

        public Criteria andSubmitBankDateIsNull() {
            addCriterion("submit_bank_date is null");
            return (Criteria) this;
        }

        public Criteria andSubmitBankDateIsNotNull() {
            addCriterion("submit_bank_date is not null");
            return (Criteria) this;
        }

        public Criteria andSubmitBankDateEqualTo(LocalDateTime value) {
            addCriterion("submit_bank_date =", value, "submitBankDate");
            return (Criteria) this;
        }

        public Criteria andSubmitBankDateNotEqualTo(LocalDateTime value) {
            addCriterion("submit_bank_date <>", value, "submitBankDate");
            return (Criteria) this;
        }

        public Criteria andSubmitBankDateGreaterThan(LocalDateTime value) {
            addCriterion("submit_bank_date >", value, "submitBankDate");
            return (Criteria) this;
        }

        public Criteria andSubmitBankDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("submit_bank_date >=", value, "submitBankDate");
            return (Criteria) this;
        }

        public Criteria andSubmitBankDateLessThan(LocalDateTime value) {
            addCriterion("submit_bank_date <", value, "submitBankDate");
            return (Criteria) this;
        }

        public Criteria andSubmitBankDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("submit_bank_date <=", value, "submitBankDate");
            return (Criteria) this;
        }

        public Criteria andSubmitBankDateLike(LocalDateTime value) {
            addCriterion("submit_bank_date like", value, "submitBankDate");
            return (Criteria) this;
        }

        public Criteria andSubmitBankDateNotLike(LocalDateTime value) {
            addCriterion("submit_bank_date not like", value, "submitBankDate");
            return (Criteria) this;
        }

        public Criteria andSubmitBankDateIn(List<LocalDateTime> values) {
            addCriterion("submit_bank_date in", values, "submitBankDate");
            return (Criteria) this;
        }

        public Criteria andSubmitBankDateNotIn(List<LocalDateTime> values) {
            addCriterion("submit_bank_date not in", values, "submitBankDate");
            return (Criteria) this;
        }

        public Criteria andSubmitBankDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("submit_bank_date between", value1, value2, "submitBankDate");
            return (Criteria) this;
        }

        public Criteria andSubmitBankDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("submit_bank_date not between", value1, value2, "submitBankDate");
            return (Criteria) this;
        }

        public Criteria andMrgeDateIsNull() {
            addCriterion("mrge_date is null");
            return (Criteria) this;
        }

        public Criteria andMrgeDateIsNotNull() {
            addCriterion("mrge_date is not null");
            return (Criteria) this;
        }

        public Criteria andMrgeDateEqualTo(LocalDateTime value) {
            addCriterion("mrge_date =", value, "mrgeDate");
            return (Criteria) this;
        }

        public Criteria andMrgeDateNotEqualTo(LocalDateTime value) {
            addCriterion("mrge_date <>", value, "mrgeDate");
            return (Criteria) this;
        }

        public Criteria andMrgeDateGreaterThan(LocalDateTime value) {
            addCriterion("mrge_date >", value, "mrgeDate");
            return (Criteria) this;
        }

        public Criteria andMrgeDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("mrge_date >=", value, "mrgeDate");
            return (Criteria) this;
        }

        public Criteria andMrgeDateLessThan(LocalDateTime value) {
            addCriterion("mrge_date <", value, "mrgeDate");
            return (Criteria) this;
        }

        public Criteria andMrgeDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("mrge_date <=", value, "mrgeDate");
            return (Criteria) this;
        }

        public Criteria andMrgeDateLike(LocalDateTime value) {
            addCriterion("mrge_date like", value, "mrgeDate");
            return (Criteria) this;
        }

        public Criteria andMrgeDateNotLike(LocalDateTime value) {
            addCriterion("mrge_date not like", value, "mrgeDate");
            return (Criteria) this;
        }

        public Criteria andMrgeDateIn(List<LocalDateTime> values) {
            addCriterion("mrge_date in", values, "mrgeDate");
            return (Criteria) this;
        }

        public Criteria andMrgeDateNotIn(List<LocalDateTime> values) {
            addCriterion("mrge_date not in", values, "mrgeDate");
            return (Criteria) this;
        }

        public Criteria andMrgeDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("mrge_date between", value1, value2, "mrgeDate");
            return (Criteria) this;
        }

        public Criteria andMrgeDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("mrge_date not between", value1, value2, "mrgeDate");
            return (Criteria) this;
        }

        public Criteria andMrgeStateIsNull() {
            addCriterion("mrge_state is null");
            return (Criteria) this;
        }

        public Criteria andMrgeStateIsNotNull() {
            addCriterion("mrge_state is not null");
            return (Criteria) this;
        }

        public Criteria andMrgeStateEqualTo(Boolean value) {
            addCriterion("mrge_state =", value, "mrgeState");
            return (Criteria) this;
        }

        public Criteria andMrgeStateNotEqualTo(Boolean value) {
            addCriterion("mrge_state <>", value, "mrgeState");
            return (Criteria) this;
        }

        public Criteria andMrgeStateGreaterThan(Boolean value) {
            addCriterion("mrge_state >", value, "mrgeState");
            return (Criteria) this;
        }

        public Criteria andMrgeStateGreaterThanOrEqualTo(Boolean value) {
            addCriterion("mrge_state >=", value, "mrgeState");
            return (Criteria) this;
        }

        public Criteria andMrgeStateLessThan(Boolean value) {
            addCriterion("mrge_state <", value, "mrgeState");
            return (Criteria) this;
        }

        public Criteria andMrgeStateLessThanOrEqualTo(Boolean value) {
            addCriterion("mrge_state <=", value, "mrgeState");
            return (Criteria) this;
        }

        public Criteria andMrgeStateLike(Boolean value) {
            addCriterion("mrge_state like", value, "mrgeState");
            return (Criteria) this;
        }

        public Criteria andMrgeStateNotLike(Boolean value) {
            addCriterion("mrge_state not like", value, "mrgeState");
            return (Criteria) this;
        }

        public Criteria andMrgeStateIn(List<Boolean> values) {
            addCriterion("mrge_state in", values, "mrgeState");
            return (Criteria) this;
        }

        public Criteria andMrgeStateNotIn(List<Boolean> values) {
            addCriterion("mrge_state not in", values, "mrgeState");
            return (Criteria) this;
        }

        public Criteria andMrgeStateBetween(Boolean value1, Boolean value2) {
            addCriterion("mrge_state between", value1, value2, "mrgeState");
            return (Criteria) this;
        }

        public Criteria andMrgeStateNotBetween(Boolean value1, Boolean value2) {
            addCriterion("mrge_state not between", value1, value2, "mrgeState");
            return (Criteria) this;
        }

        public Criteria andBorrowRegCertDateIsNull() {
            addCriterion("borrow_reg_cert_date is null");
            return (Criteria) this;
        }

        public Criteria andBorrowRegCertDateIsNotNull() {
            addCriterion("borrow_reg_cert_date is not null");
            return (Criteria) this;
        }

        public Criteria andBorrowRegCertDateEqualTo(LocalDateTime value) {
            addCriterion("borrow_reg_cert_date =", value, "borrowRegCertDate");
            return (Criteria) this;
        }

        public Criteria andBorrowRegCertDateNotEqualTo(LocalDateTime value) {
            addCriterion("borrow_reg_cert_date <>", value, "borrowRegCertDate");
            return (Criteria) this;
        }

        public Criteria andBorrowRegCertDateGreaterThan(LocalDateTime value) {
            addCriterion("borrow_reg_cert_date >", value, "borrowRegCertDate");
            return (Criteria) this;
        }

        public Criteria andBorrowRegCertDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("borrow_reg_cert_date >=", value, "borrowRegCertDate");
            return (Criteria) this;
        }

        public Criteria andBorrowRegCertDateLessThan(LocalDateTime value) {
            addCriterion("borrow_reg_cert_date <", value, "borrowRegCertDate");
            return (Criteria) this;
        }

        public Criteria andBorrowRegCertDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("borrow_reg_cert_date <=", value, "borrowRegCertDate");
            return (Criteria) this;
        }

        public Criteria andBorrowRegCertDateLike(LocalDateTime value) {
            addCriterion("borrow_reg_cert_date like", value, "borrowRegCertDate");
            return (Criteria) this;
        }

        public Criteria andBorrowRegCertDateNotLike(LocalDateTime value) {
            addCriterion("borrow_reg_cert_date not like", value, "borrowRegCertDate");
            return (Criteria) this;
        }

        public Criteria andBorrowRegCertDateIn(List<LocalDateTime> values) {
            addCriterion("borrow_reg_cert_date in", values, "borrowRegCertDate");
            return (Criteria) this;
        }

        public Criteria andBorrowRegCertDateNotIn(List<LocalDateTime> values) {
            addCriterion("borrow_reg_cert_date not in", values, "borrowRegCertDate");
            return (Criteria) this;
        }

        public Criteria andBorrowRegCertDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("borrow_reg_cert_date between", value1, value2, "borrowRegCertDate");
            return (Criteria) this;
        }

        public Criteria andBorrowRegCertDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("borrow_reg_cert_date not between", value1, value2, "borrowRegCertDate");
            return (Criteria) this;
        }

        public Criteria andMrgeSendCarAdminDateIsNull() {
            addCriterion("mrge_send_car_admin_date is null");
            return (Criteria) this;
        }

        public Criteria andMrgeSendCarAdminDateIsNotNull() {
            addCriterion("mrge_send_car_admin_date is not null");
            return (Criteria) this;
        }

        public Criteria andMrgeSendCarAdminDateEqualTo(LocalDateTime value) {
            addCriterion("mrge_send_car_admin_date =", value, "mrgeSendCarAdminDate");
            return (Criteria) this;
        }

        public Criteria andMrgeSendCarAdminDateNotEqualTo(LocalDateTime value) {
            addCriterion("mrge_send_car_admin_date <>", value, "mrgeSendCarAdminDate");
            return (Criteria) this;
        }

        public Criteria andMrgeSendCarAdminDateGreaterThan(LocalDateTime value) {
            addCriterion("mrge_send_car_admin_date >", value, "mrgeSendCarAdminDate");
            return (Criteria) this;
        }

        public Criteria andMrgeSendCarAdminDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("mrge_send_car_admin_date >=", value, "mrgeSendCarAdminDate");
            return (Criteria) this;
        }

        public Criteria andMrgeSendCarAdminDateLessThan(LocalDateTime value) {
            addCriterion("mrge_send_car_admin_date <", value, "mrgeSendCarAdminDate");
            return (Criteria) this;
        }

        public Criteria andMrgeSendCarAdminDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("mrge_send_car_admin_date <=", value, "mrgeSendCarAdminDate");
            return (Criteria) this;
        }

        public Criteria andMrgeSendCarAdminDateLike(LocalDateTime value) {
            addCriterion("mrge_send_car_admin_date like", value, "mrgeSendCarAdminDate");
            return (Criteria) this;
        }

        public Criteria andMrgeSendCarAdminDateNotLike(LocalDateTime value) {
            addCriterion("mrge_send_car_admin_date not like", value, "mrgeSendCarAdminDate");
            return (Criteria) this;
        }

        public Criteria andMrgeSendCarAdminDateIn(List<LocalDateTime> values) {
            addCriterion("mrge_send_car_admin_date in", values, "mrgeSendCarAdminDate");
            return (Criteria) this;
        }

        public Criteria andMrgeSendCarAdminDateNotIn(List<LocalDateTime> values) {
            addCriterion("mrge_send_car_admin_date not in", values, "mrgeSendCarAdminDate");
            return (Criteria) this;
        }

        public Criteria andMrgeSendCarAdminDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("mrge_send_car_admin_date between", value1, value2, "mrgeSendCarAdminDate");
            return (Criteria) this;
        }

        public Criteria andMrgeSendCarAdminDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("mrge_send_car_admin_date not between", value1, value2, "mrgeSendCarAdminDate");
            return (Criteria) this;
        }

        public Criteria andMrgeBackDateIsNull() {
            addCriterion("mrge_back_date is null");
            return (Criteria) this;
        }

        public Criteria andMrgeBackDateIsNotNull() {
            addCriterion("mrge_back_date is not null");
            return (Criteria) this;
        }

        public Criteria andMrgeBackDateEqualTo(LocalDateTime value) {
            addCriterion("mrge_back_date =", value, "mrgeBackDate");
            return (Criteria) this;
        }

        public Criteria andMrgeBackDateNotEqualTo(LocalDateTime value) {
            addCriterion("mrge_back_date <>", value, "mrgeBackDate");
            return (Criteria) this;
        }

        public Criteria andMrgeBackDateGreaterThan(LocalDateTime value) {
            addCriterion("mrge_back_date >", value, "mrgeBackDate");
            return (Criteria) this;
        }

        public Criteria andMrgeBackDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("mrge_back_date >=", value, "mrgeBackDate");
            return (Criteria) this;
        }

        public Criteria andMrgeBackDateLessThan(LocalDateTime value) {
            addCriterion("mrge_back_date <", value, "mrgeBackDate");
            return (Criteria) this;
        }

        public Criteria andMrgeBackDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("mrge_back_date <=", value, "mrgeBackDate");
            return (Criteria) this;
        }

        public Criteria andMrgeBackDateLike(LocalDateTime value) {
            addCriterion("mrge_back_date like", value, "mrgeBackDate");
            return (Criteria) this;
        }

        public Criteria andMrgeBackDateNotLike(LocalDateTime value) {
            addCriterion("mrge_back_date not like", value, "mrgeBackDate");
            return (Criteria) this;
        }

        public Criteria andMrgeBackDateIn(List<LocalDateTime> values) {
            addCriterion("mrge_back_date in", values, "mrgeBackDate");
            return (Criteria) this;
        }

        public Criteria andMrgeBackDateNotIn(List<LocalDateTime> values) {
            addCriterion("mrge_back_date not in", values, "mrgeBackDate");
            return (Criteria) this;
        }

        public Criteria andMrgeBackDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("mrge_back_date between", value1, value2, "mrgeBackDate");
            return (Criteria) this;
        }

        public Criteria andMrgeBackDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("mrge_back_date not between", value1, value2, "mrgeBackDate");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNull() {
            addCriterion("staff_id is null");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNotNull() {
            addCriterion("staff_id is not null");
            return (Criteria) this;
        }

        public Criteria andStaffIdEqualTo(Long value) {
            addCriterion("staff_id =", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotEqualTo(Long value) {
            addCriterion("staff_id <>", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThan(Long value) {
            addCriterion("staff_id >", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThanOrEqualTo(Long value) {
            addCriterion("staff_id >=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThan(Long value) {
            addCriterion("staff_id <", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThanOrEqualTo(Long value) {
            addCriterion("staff_id <=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLike(Long value) {
            addCriterion("staff_id like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotLike(Long value) {
            addCriterion("staff_id not like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdIn(List<Long> values) {
            addCriterion("staff_id in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotIn(List<Long> values) {
            addCriterion("staff_id not in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdBetween(Long value1, Long value2) {
            addCriterion("staff_id between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotBetween(Long value1, Long value2) {
            addCriterion("staff_id not between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIsNull() {
            addCriterion("is_deleted is null");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIsNotNull() {
            addCriterion("is_deleted is not null");
            return (Criteria) this;
        }

        public Criteria andIsDeletedEqualTo(Integer value) {
            addCriterion("is_deleted =", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotEqualTo(Integer value) {
            addCriterion("is_deleted <>", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedGreaterThan(Integer value) {
            addCriterion("is_deleted >", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_deleted >=", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLessThan(Integer value) {
            addCriterion("is_deleted <", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLessThanOrEqualTo(Integer value) {
            addCriterion("is_deleted <=", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLike(Integer value) {
            addCriterion("is_deleted like", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotLike(Integer value) {
            addCriterion("is_deleted not like", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIn(List<Integer> values) {
            addCriterion("is_deleted in", values, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotIn(List<Integer> values) {
            addCriterion("is_deleted not in", values, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedBetween(Integer value1, Integer value2) {
            addCriterion("is_deleted between", value1, value2, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotBetween(Integer value1, Integer value2) {
            addCriterion("is_deleted not between", value1, value2, "isDeleted");
            return (Criteria) this;
        }

    }

    /**
     * This class corresponds to the database table pcl_notary_mortgage
    */
    public  static class Criteria extends GeneratedCriteria{
        protected Criteria() {
            super();
        }
    }



    @Override
    public String toString(){
        return ReflectionToStringBuilder.toString(this, ToStringStyle.DEFAULT_STYLE);
    }
}